![](/template/termwiki/images/likesmall.jpg)
Home > Answers > What formula can I use in Excel 2007 to create one list twa1310542573
What formula can I use in Excel 2007 to create one list from another?
Please see the image for a visual representation of this. The left-hand list contains the information I want, at regular intervals of 3 rows. I want to copy only this information into a list on the right, which would no longer be separated by rows.
I've already tried 2 things: in C1, C2 and C3 putting =A1, =A4 and =A7, but when I highlight and pull down to copy the formula, the formula doesn't continue upwards (i.e. A10, A13 etc.) so the results are inaccurate.
I've also tried =A3, =A(3+5), but it doesn't like the brackets at all.
Although the question is quite complex, what I am asking is actually very simple.
Does anyone have a solution?
- Pramonės šaka / sritis: Software
- Category: Productivity software
- Created: 02:36, 13 July 2011
Kūrėjas
Featured blossaries
Blossary
0
Terms
4
Aiškinamieji žodynai
7
Followers
Neology Blossary
Kategorija: Languages 1
2 Terms
![](/template/termwiki/images/likesmall.jpg)
stanley soerianto
0
Terms
107
Aiškinamieji žodynai
6
Followers
Top 10 Best Shoe Brands
Kategorija: Fashion 1
10 Terms
![](/template/termwiki/images/likesmall.jpg)
![](https://accounts.termwiki.com/thumb1.php?f=6c851670-1401335790.png&width=304&height=180)
dnatalia
0
Terms
60
Aiškinamieji žodynai
2
Followers
Blood Types and Personality
Kategorija: Entertainment 2
4 Terms
![](/template/termwiki/images/likesmall.jpg)
![](https://accounts.termwiki.com/thumb1.php?f=92a77f57-1408502655.jpg&width=304&height=180)
Sysop20160518
0
Terms
1
Aiškinamieji žodynai
1
Followers
Linguistics
Kategorija: Languages 1
10 Terms
![](/template/termwiki/images/likesmall.jpg)
![](https://accounts.termwiki.com/thumb1.php?f=8bf4966c-1414629501.jpg&width=304&height=180)